{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["MSU","MYP, MSS","Arvo-ottelut","Kärkilyönnit"],"read":"whole","date_system":"1900"}

{"sheet":"MSU","index":0,"n_rows":31,"n_cols":43,"rows_kept":31}
[null,"Valtteri Kleemola",null,null,"23.1.1995   Ulvila"]
[null,"SUPERPESIS",null,null,"Runkosarja",{"$nulls":3},"  Kärkilyönnit (KL),  pesänvälit",{"$nulls":6},"       Runkosarja TOP-30",{"$nulls":4},"Alempi loppusarja",{"$nulls":6},"Ylempi loppusarja TOP-10",{"$nulls":4},"Play off, voitot, voittoprosentti",{"$nulls":4}," Arvo-ottelut",null,null,"      Mitalit"]
[null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","0 > 1","1 > 2","2 > 3","3 > k","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"Puolivälierät","Välierät","Pronssi","Finaalit",null,"IL","LL","hSM","K","H","P"]
[null,2011,"5.","UPV",null,"poikien superpesis"]
[null,2012,"3.","UPV",null,"ykköspesis"]
[null,2013,"6.","UPV",null,"ykköspesis"]
[null,2014,"4.","UPV",null,"ykköspesis"]
[null,2015,"12.","KaMa   ",30,0,2,3,52,23,21,6,2,{"v":0.3513,"d":"35.1 %"},148]
[null,2016,"11.","KaMa   ",27,0,4,6,62,26,25,7,4,{"v":0.443,"d":"44.3 %"},140]
[null,2017,"13.","KaMa",28,1,0,15,83,61,9,12,1,{"v":0.5286,"d":"52.9 %"},157]
[null,2018,"12.","AA",26,1,10,13,82,25,33,13,11,{"v":0.503,"d":"50.3 %"},163.02186878727633]
[null,2019,"12.","KeKi",24,1,3,10,63,25,19,15,4,{"v":0.4144,"d":"41.4 %"},152]
[null,2020,"10.","KeKi",22,3,4,8,49,13,16,13,7,{"v":0.4949,"d":"49.5 %"},99]
[null,2021,"4.","KeKi  2",null,"suomensarja"]
[null,2021,"6.","KeKi",7,1,3,1,12,1,2,5,4,{"v":0.5217,"d":"52.2 %"},23]
[null,2020,"7.","SiKi",null,"ykköspesis"]
[null,"Yhteensä",null,null,{"$f":"SUM(E4:E16)","v":164},7,26,56,403,174,125,71,33,{"$f":"PRODUCT(I17/O17)","v":{"v":0.456904771028069,"d":"45.7 %"}},{"$f":"SUM(O3:O16)","v":882.0218687872764},"0-0-0","0-0-0","0-0-0","0-0-0",null,{"$f":"SUM(U4:U16)","v":0},0,0,0,0,{"v":0.539,"d":"53.9 %"},null,"0-0-0","0-0-0","0-0-0","0-0-0",null,"0/0","0/0","0/0","0/0",null,{"$f":"SUM(AL4:AL16)","v":0},0,0,0,0,0]
[{"$nulls":32},{"v":0,"d":"0.0 %"},{"v":0,"d":"0.0 %"},{"v":0,"d":"0.0 %"},{"v":0,"d":"0.0 %"}]
[null,"Pesispörssi",null,{"$f":"SUM(F17:H17)+((I17-F17-G17)/3)+(E17/3)+(AL17*25)+(AM17*25)+(AN17*10)+(AO17*25)+(AP17*20)+(AQ17*15)","v":{"v":267,"d":"267.0"}}]
[]
[null,"URA SUPERISSA",null,null,"OTT","KUN","LÖI","TOI","KL",null,"ka/L","ka/T","ka/KL","KL-%",null,"ENSIMMÄISET RUNKOSARJASSA",{"$nulls":16},"ENSIMMÄISET PUDOTUSPELEISSÄ",{"$nulls":4},"YLEISÖ"]
[null,"Runkosarja",null,null,{"$f":"PRODUCT(E17)","v":164},{"$f":"PRODUCT(F17)","v":7},{"$f":"PRODUCT(G17)","v":26},{"$f":"PRODUCT(H17)","v":56},{"$f":"PRODUCT(I17)","v":403},null,{"$f":"PRODUCT((F22+G22)/E22)","v":{"v":0.20121951219512196,"d":"0.20"}},{"$f":"PRODUCT(H22/E22)","v":{"v":0.34146341463414637,"d":"0.34"}},{"$f":"PRODUCT(I22/E22)","v":{"v":2.457317073170732,"d":"2.46"}},{"$f":"PRODUCT(N17)","v":{"v":0.456904771028069,"d":"45.7 %"}},{"$f":"PRODUCT(O17)","v":882.0218687872764},"Ottelu",null,"10.05. 2015  KaMa - KiPa  0-2  (0-5, 1-3)",{"$nulls":8},"1.  ottelu",null,"  20 v   3 kk 17 pv",{"$nulls":3},"Ottelu"]
[null,"Ylempi loppusarja",{"$nulls":13},"Lyöty",null,"21.05. 2015  KaMa - Kiri  1-2  (4-0, 2-8, 0-1)",{"$nulls":8},"4.  ottelu",null,"  20 v   3 kk 28 pv",{"$nulls":3},"Lyöty"]
[null,"Alempi loppusarja",null,null,12,3,10,9,41,null,{"$f":"PRODUCT((F24+G24)/E24)","v":{"v":1.0833333333333333,"d":"1.08"}},{"$f":"PRODUCT(H24/E24)","v":0.75},{"$f":"PRODUCT(I24/E24)","v":{"v":3.4166666666666665,"d":"3.42"}},{"$f":"PRODUCT(I24/O24)","v":{"v":0.5394736842105263,"d":"53.9 %"}},76,"Tuotu",null,"26.05. 2015  KaMa - AA  2-1  (6-5, 2-5, 2-0)",{"$nulls":8},"6.  ottelu",null,"  20 v   4 kk   3 pv",{"$nulls":3},"Tuotu"]
[null,"KAIKKI",null,null,{"$f":"SUM(E22:E24)","v":176},{"$f":"SUM(F22:F24)","v":10},{"$f":"SUM(G22:G24)","v":36},{"$f":"SUM(H22:H24)","v":65},{"$f":"SUM(I22:I24)","v":444},null,{"$f":"PRODUCT((F25+G25)/E25)","v":{"v":0.26136363636363635,"d":"0.26"}},{"$f":"PRODUCT(H25/E25)","v":{"v":0.3693181818181818,"d":"0.37"}},{"$f":"PRODUCT(I25/E25)","v":{"v":2.522727272727273,"d":"2.52"}},{"$f":"PRODUCT(I25/O25)","v":{"v":0.46345497369704386,"d":"46.3 %"}},{"$f":"SUM(O22:O24)","v":958.0218687872764},"Kunnari",null,"21.05. 2017  KiPa - KaMa  1-2  (0-2, 5-1, 0-1)",{"$nulls":8},"61.  ottelu  ",null,"  17 v   6 kk 17 pv",{"$nulls":3},"Kunnari"]
[{"$nulls":14},{"$f":"SUM(O23:O25)","v":1034.0218687872764}]
[null,"Seurat",null,"UPV = Ulvilan Pesä-Veikot  (1957),  kasvattajaseura"]
[{"$nulls":3},"KaMa = Kankaanpään Maila  (1958)"]
[{"$nulls":3},"AA = Alajärven Ankkurit  (1944)"]
[{"$nulls":3},"KeKi = Kempeleen Kiri  (1915)"]
[{"$nulls":3},"SiKi = Simon Kiri  (1926)"]

{"sheet":"MYP, MSS","index":1,"n_rows":16,"n_cols":45,"rows_kept":16}
[null,"Valtteri Kleemola",null,null,"23.1.1995   Ulvila"]
[null,"YKKÖSPESIS",null,null,"Runkosarja",{"$nulls":6},"    Runkosarja TOP-10",{"$nulls":4},"Jatkosarjat",{"$nulls":6},"SUOMENSARJA",null,null,"Runkosarja",{"$nulls":6},"  Runkosarja TOP-10",{"$nulls":4},"Jatkosarjat"]
[null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%"]
[null,2012,"3.","UPV",3,0,0,2,3,{"v":0.167,"d":"16.7 %"},18,{"$nulls":5},1,1,2,1,6,{"v":0.667,"d":"66.7 %"},9]
[null,2013,"6.","UPV",22,0,3,12,52,{"v":0.43,"d":"43.0 %"},121]
[null,2014,"4.","UPV",21,0,2,9,53,{"v":0.457,"d":"45.7 %"},116,{"$nulls":5},3,0,0,2,7,{"v":0.368,"d":"36.8 %"},19]
[]
[{"$nulls":23},2021,"4.","KeKi  2",1,0,1,3,4,{"v":0.6667,"d":"66.7 %"},6]
[null,2022,"7.","SiKi",19,2,27,14,81,{"v":0.587,"d":"58.7 %"},138]
[null,"YHTEENSÄ",null,null,{"$f":"SUM(E4:E9)","v":65},{"$f":"SUM(F4:F9)","v":2},{"$f":"SUM(G4:G9)","v":32},{"$f":"SUM(H4:H9)","v":37},{"$f":"SUM(I4:I9)","v":189},{"$f":"PRODUCT(I10/K10)","v":{"v":0.48091603053435117,"d":"48.1 %"}},{"$f":"SUM(K4:K9)","v":393},{"$nulls":5},{"$f":"SUM(Q4:Q9)","v":4},{"$f":"SUM(R4:R9)","v":1},{"$f":"SUM(S4:S9)","v":2},{"$f":"SUM(T4:T9)","v":3},{"$f":"SUM(U4:U9)","v":13},{"$f":"PRODUCT(U10/W10)","v":{"v":0.4642857142857143,"d":"46.4 %"}},{"$f":"SUM(W4:W9)","v":28},"YHTEENSÄ",null,null,{"$f":"SUM(AA4:AA9)","v":1},{"$f":"SUM(AB4:AB9)","v":0},{"$f":"SUM(AC4:AC9)","v":1},{"$f":"SUM(AD4:AD9)","v":3},{"$f":"SUM(AE4:AE9)","v":4},{"$f":"PRODUCT(AE10/AG10)","v":{"v":0.6666666666666666,"d":"66.7 %"}},{"$f":"SUM(AG4:AG9)","v":6},{"$nulls":5},{"$f":"SUM(AM4:AM9)","v":0},{"$f":"SUM(AN4:AN9)","v":0},{"$f":"SUM(AO4:AO9)","v":0},{"$f":"SUM(AP4:AP9)","v":0},{"$f":"SUM(AQ4:AQ9)","v":0},{"v":0,"d":"0.0 %"},{"$f":"SUM(AS4:AS9)","v":0}]
[]
[null,"KAIKKI OTTELUT",null,null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"ka/L","ka/T","ka/l+t","ka/kl",null,null,"Seurat",null,"UPV = Ulvilan Pesä-Veikot  (1957),  kasvattajaseura"]
[null,"SUPERPESIS",null,null,176,10,36,65,444,{"v":0.463,"d":"46.3 %"},{"$f":"PRODUCT(I13/J13)","v":958.963282937365},{"$f":"PRODUCT((F13+G13)/E13)","v":{"v":0.26136363636363635,"d":"0.26"}},{"$f":"PRODUCT(H13/E13)","v":{"v":0.3693181818181818,"d":"0.37"}},{"$f":"PRODUCT((F13+G13+H13)/E13)","v":{"v":0.6306818181818182,"d":"0.63"}},{"$f":"PRODUCT(I13/E13)","v":{"v":2.522727272727273,"d":"2.52"}},{"$nulls":4},"KaMa = Kankaanpään Maila  (1958)"]
[null,"YKKÖSPESIS",null,null,{"$f":"PRODUCT(E10+Q10)","v":69},{"$f":"PRODUCT(F10+R10)","v":3},{"$f":"PRODUCT(G10+S10)","v":34},{"$f":"PRODUCT(H10+T10)","v":40},{"$f":"PRODUCT(I10+U10)","v":202},{"$f":"PRODUCT(I14/K14)","v":{"v":0.47980997624703087,"d":"48.0 %"}},{"$f":"PRODUCT(K10+W10)","v":421},{"$f":"PRODUCT((F14+G14)/E14)","v":{"v":0.5362318840579711,"d":"0.54"}},{"$f":"PRODUCT(H14/E14)","v":{"v":0.5797101449275363,"d":"0.58"}},{"$f":"PRODUCT((F14+G14+H14)/E14)","v":{"v":1.1159420289855073,"d":"1.12"}},{"$f":"PRODUCT(I14/E14)","v":{"v":2.927536231884058,"d":"2.93"}},{"$nulls":4},"AA = Alajärven Ankkurit  (1944)"]
[null,"SUOMENSARJA",null,null,{"$f":"PRODUCT(AA10+AM10)","v":1},{"$f":"PRODUCT(AB10+AN10)","v":0},{"$f":"PRODUCT(AC10+AO10)","v":1},{"$f":"PRODUCT(AD10+AP10)","v":3},{"$f":"PRODUCT(AE10+AQ10)","v":4},{"$f":"PRODUCT(I15/K15)","v":{"v":0.6666666666666666,"d":"66.7 %"}},{"$f":"PRODUCT(AG10)","v":6},{"$f":"PRODUCT((F15+G15)/E15)","v":{"v":1,"d":"1.00"}},{"$f":"PRODUCT(H15/E15)","v":{"v":3,"d":"3.00"}},{"$f":"PRODUCT((F15+G15+H15)/E15)","v":{"v":4,"d":"4.00"}},{"$f":"PRODUCT(I15/E15)","v":{"v":4,"d":"4.00"}},{"$nulls":4},"KeKi = Kempeleen Kiri  (1915)"]
[null,"YHTEENSÄ",null,null,{"$f":"SUM(E13:E15)","v":246},{"$f":"SUM(F13:F15)","v":13},71,108,650,{"$f":"PRODUCT(I16/K16)","v":{"v":0.4689878931153294,"d":"46.9 %"}},{"$f":"SUM(K13:K15)","v":1385.963282937365},{"$f":"PRODUCT((F16+G16)/E16)","v":{"v":0.34146341463414637,"d":"0.34"}},{"$f":"PRODUCT(H16/E16)","v":{"v":0.43902439024390244,"d":"0.44"}},{"$f":"PRODUCT((F16+G16+H16)/E16)","v":{"v":0.7804878048780488,"d":"0.78"}},{"$f":"PRODUCT(I16/E16)","v":{"v":2.6422764227642275,"d":"2.64"}},{"$nulls":4},"SiKi = Simon Kiri  (1926)"]

{"sheet":"Arvo-ottelut","index":2,"n_rows":9,"n_cols":24,"rows_kept":9}
[null," ITÄ - LÄNSI - KORTTI"]
[null,"Valtteri Kleemola","23.1.1995   Ulvila"]
[null,"B-POJAT","  Itä - Länsi, tulos","Joukkue","Seura",null,"V","T","H","Up.","Lj.","Palk.","O","K","L","T","KL",1,2,3,"k","KL-%","Pelinjohtaja      "," Yleisöä"]
[null,"14.07. 2013  Hyvinkää","  0-2  (3-4, 2-6)","Länsi","VäVi",null,1,null,null,"2k",7,null,1,{"$nulls":3},"4/5","1/2",null,"3/3",null,{"v":0.8,"d":"80.0 %"},"Pasi Vanhatalo",1287]
[]
[null,"A-POJAT","  Itä - Länsi, tulos","Joukkue","Seura",null,"V","T","H","Up.","Lj.","Palk.","O","K","L","T","KL",1,2,3,"k","KL-%","Pelinjohtaja      "," Yleisöä"]
[null,"26.06. 2015  Hyvinkää","  0-1  (2-5, 2-2)","Länsi","KaMa",null,1,null,null,"2v",8,null,1,{"$nulls":3},"3/7","2/5",null,"1/2",null,{"v":0.429,"d":"42.9 %"},"Jussi Parvi",842]
[null,"01.07. 2016  Kouvola","  1-2  (2-1, 6-10, 1-2)","Länsi","KaMa",null,1,null,null,"2p",4,"I p",1,null,1,1,"6/9",null,"3/4","2/3","1/2",{"v":0.667,"d":"66.7 %"},"Jussi Parvi",1236]
[null,"Yhteensä",{"$nulls":4},2,{"$nulls":5},2,null,1,1,"9/16","2/5","3/4","3/5","1/2",{"v":0.563,"d":"56.3 %"}]

{"sheet":"Kärkilyönnit","index":3,"n_rows":11,"n_cols":29,"rows_kept":11}
[null,"KÄRKILYÖNNIT RUNKOSARJASSA",{"$nulls":19},"VUOSITTAISET SIJOITUKSET  TOP - 30"]
[{"$nulls":6},"0 > 1",null,null,"1 > 2",null,null,"2 > 3",null,null,"3 > k",null,null,"Yhteensä"]
[null,"Vuosi","Sija","Seura","OTT","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%",null,"Vuosi","Sija","Seura","0 > 1","1 > 2","2 > 3","3 > k","KL"]
[null,2015,"12.","KaMa   ",30,23,71,{"v":0.3239,"d":"32.4 %"},21,53,{"v":0.3962,"d":"39.6 %"},6,17,{"v":0.3529,"d":"35.3 %"},2,7,{"v":0.2857,"d":"28.6 %"},52,148,{"v":0.35135135135135137,"d":"35.1 %"},null,2015,"12.","KaMa   "]
[null,2016,"11.","KaMa   ",27,26,55,{"v":0.4727,"d":"47.3 %"},25,44,{"v":0.5681,"d":"56.8 %"},7,21,{"v":0.3333,"d":"33.3 %"},4,20,{"v":0.2,"d":"20.0 %"},62,140,{"v":0.44285714285714284,"d":"44.3 %"},null,2016,"11.","KaMa   "]
[null,2017,"13.","KaMa",28,61,97,{"v":0.6288,"d":"62.9 %"},9,23,{"v":0.3913,"d":"39.1 %"},12,29,{"v":0.4137,"d":"41.4 %"},1,8,{"v":0.125,"d":"12.5 %"},83,157,{"v":0.5286624203821656,"d":"52.9 %"},null,2017,"13.","KaMa","23."]
[null,2018,"12.","AA",26,25,47,{"v":0.5319,"d":"53.2 %"},33,66,{"v":0.5,"d":"50.0 %"},13,25,{"v":0.52,"d":"52.0 %"},11,25,{"v":0.44,"d":"44.0 %"},82,163,{"v":0.503,"d":"50.3 %"},null,2018,"12.","AA"]
[null,2019,"12.","KeKi",24,25,63,{"v":0.3968,"d":"39.7 %"},19,47,{"v":0.4042,"d":"40.4 %"},15,31,{"v":0.4838,"d":"48.4 %"},4,11,{"v":0.3636,"d":"36.4 %"},63,152,{"v":0.4144736842105263,"d":"41.4 %"},null,2019,"12.","KeKi"]
[null,2020,"10.","KeKi",22,13,23,{"v":0.5652,"d":"56.5 %"},16,30,{"v":0.5333,"d":"53.3 %"},13,31,{"v":0.4193,"d":"41.9 %"},7,15,{"v":0.4666,"d":"46.7 %"},49,99,{"v":0.494949494949495,"d":"49.5 %"},null,2020,"10.","KeKi"]
[null,2021,"6.","KeKi",7,1,4,{"v":0.25,"d":"25.0 %"},2,6,{"v":0.3333,"d":"33.3 %"},5,8,{"v":0.625,"d":"62.5 %"},4,5,{"v":0.8,"d":"80.0 %"},12,23,{"v":0.5217,"d":"52.2 %"},null,2021,"6.","KeKi"]
[null,"Yhteensä",null,null,{"$f":"SUM(E4:E10)","v":164},{"$f":"SUM(F4:F10)","v":174},{"$f":"SUM(G4:G10)","v":360},{"$f":"PRODUCT(F11/G11)","v":{"v":0.48333333333333334,"d":"48.3 %"}},{"$f":"SUM(I4:I10)","v":125},{"$f":"SUM(J4:J10)","v":269},{"$f":"PRODUCT(I11/J11)","v":{"v":0.4646840148698885,"d":"46.5 %"}},{"$f":"SUM(L4:L10)","v":71},{"$f":"SUM(M4:M10)","v":162},{"$f":"PRODUCT(L11/M11)","v":{"v":0.4382716049382716,"d":"43.8 %"}},{"$f":"SUM(O4:O10)","v":33},{"$f":"SUM(P4:P10)","v":91},{"$f":"PRODUCT(O11/P11)","v":{"v":0.3626373626373626,"d":"36.3 %"}},{"$f":"SUM(R4:R10)","v":403},{"$f":"SUM(S4:S10)","v":882},{"$f":"PRODUCT(R11/S11)","v":{"v":0.45691609977324266,"d":"45.7 %"}}]